{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview ","Instructions","Log of changes","5.7","Influence chart","Assumptions","5.8 Long-term Model","Short-Term Results","Historical data","Ratio charts"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview ","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
["BRL 1/13/05"]
["BRL 5/3/05"]
["BRL 9/29/05",null,"Purposes of the Planning Model"]
[]
[null,null,"The purposes for developing a 'business planning' model for the Northern Museum is to provide a tool for the Museum Board, Executive "]
[null,null,"Director and Staff to develop, analyze and modify annual budgets (on a quarterly basis), make forecasts of future costs and revenues, and consider the possible "]
[null,null,"impacts of major changes to the programs, personnel, capital expenditures or endowment strategies.  It should provide the 'big picture' on the Museum financial situation."]
[]
[null,null,"This model has been designed and developed by a Spreadsheet Engineering Team at Tuck School at Dartmouth College in collaboration with the Finance"]
[null,null,"Committee of the Northern Museum.  That committee has provided guidance regarding the purposes of the model as well as the principal uses to which "]
[null,null,"the model is to be used.  The model has gone through a number of iterations during 2004 and 2005, and it will be tested against these intended uses as time goes on."]
[]
[null,null,"Simplicity is the bottom line of the design.  In fact, as one of the Museum Board members said, \"It is better to be approximately right, than to be precisely wrong.\""]
[null,null,"The model is just that - a model.  It is intended to portray many of the interrelationships that exist among the Museum's programs and operations, expressed through"]
[null,null,"its finances and financial system.  The model is also integrated with the recently revised financial accounting system of the Museum in order to make the"]
[null,null,"language' and the mathematical relationships within the model as close to the real world as necessary to gain understanding of the causal effects of"]
[null,null,"Museum decisions.  Sensitivity analysis will be encouraged, and space provided for the results of such analysis."]
[]
[null,null,"There is no pretense that the model will provide accurate forecasts of the future financial situation of the Museum; however, the model should"]
[null,null,"provide insight into probable effects on tomorrow of decisions made today.  The basic model is specifically designed to portray the normal operations"]
[null,null,"of the institution without any influence from extraordinary financial commitments or inflows.  This basic model will be the focus of attention in the early"]
[null,null,"design and use to ensure that there is confidence that this version of model has 'integrity' and can be judged sufficiently valid to be useful for the number"]
[null,null,"of functions for which it is designed."]
[]
[null,null,"Once this basic model has been approved and adopted, the model designers will prepare additional spreadsheet modules that will be integrated with the basic "]
[null,null,"model to permit analysis and evaluation of more sophisticated policy decisions, e.g., the effects of introducing new Museum programs, hiring new staff, engaging in"]
[null,null," a capital campaign, and/or investing in new facilities.  The expanded model will then become more useful as a forecasting tool, at least reflecting many of the "]
[null,null,"impacts that should be anticipated with a major financial decision."]
[]
[null,null,"The Workbook will also include historical information so that, over time, as new information is gathered and Museum performance monitored, this"]
[null,null,"information can inform model users regarding assumptions to be used for the future.  It is anticipated that the principal interest of model users will be on the"]
[null,null,"forthcoming three-year period.  The model will extend forecasts beyond three years, but it is understood that these longer term forecasts must be viewed"]
[null,null,"with more caution.  The model also includes a sub-model that is to be used during the capital campaign (and will eventually be integrated with the business model)."]
[]
[null,null,"\"I think the most important assumption that  ",null,null,null,null,null,null,null,null,"look at the same old numbers, then it will be an exercise in frustration."]
[null,null,"must underpin this work is that the museum will exercise both discipline and",null,null,null,null,null,null,null,null,"I think we are not quite at the level of complete commitment, and probably"]
[null,null,"informed judgment in the consistent use of the model.   This isn't about",null,null,null,null,null,null,null,null,"won't be until others have time to look at, digest, and understand the"]
[null,null,"reporting results; it's about planning for and monitoring the financial (and",null,null,null,null,null,null,null,null,"potential of the model.  This would include the new Board leadership; the"]
[null,null,"programmatic) health of the museum at the strategic and tactical levels.  If",null,null,null,null,null,null,null,null,"management team; and Board committee chairs, at the very least.  "]
[null,null,"we can integrate this model into our strategic planning, with a commitment"]
[null,null,"from the institution at all levels to apply it, study it, and use it wisely,",null,null,null,null,null,null,null,null," - Executive Director, Northern Museum"]
[null,null,"then it will have tremendous value.   If we regard it as just another way to"]

{"sheet":"Instructions","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
[]
[null,"How to use this model:"]
[]
[null,1,"The user should first become acquainted with the model, the workbook, and all the worksheets.  The purpose of the model is to help with annual and semi-annual planning"]
[null,2,"The three principal sheets are Assumptions, Long Term Model, and Short Term Results.  The Long Term Model sheet contains the projections that emanate from the assumptions. "]
[null,null,"The Short Term Results sheet summarizes the information primarily for the one-year and three-year time frame.  "]
[null,null,"It also provides an overview of the differences among the base case as well as Options I and II."]
[null,null,"Option I is to be used as a more pessimistic view of the future, while Option II is more optimistic.  However, they can be used and defined as the user wishes."]
[null,null,"Input into the Assumptions sheet automatically gets translated into the Long Term Model and Short Term Results sheets."]
[null,3,"With this as background, the user focuses on the Assumptions sheet, entering assumptions for the base case and the two options."]
[null,null,"Cells in which data is required are in light yellow."]
[null,4,"The Long Term Model and the Short Term Results sheets provide information based on the model and the user's inputs.  After reviewing the results, the user may wish to vary assumptions."]
[null,5,"It is suggested that each run of the model be saved and documented [e.g., user initial, date, version #]"]
[null,6,"The model should be useful at least twice a year - once when the annual budget is being formulated, and again half way through the year."]
[null,null,"However, new information (e.g., past year data) or changes of some magnitude in the Museum's operation should be reflected in the model."]
[null,7,"On the Long Term Model sheet there is a column that uses the information from the past year in Column C.  "]
[null,null,"The Short Term Results sheet  uses information projected for the following or current year in Column U."]
[null,8,"Special attention must be given to the Endowment.  As of now, there is only one assumption (rate of return), but more is needed in terms of investment management fee,"]
[null,null," and other special withdrawals and deposits."]

{"sheet":"Log of changes","index":2,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
[]
[]
[]
[null,"Note: On May 11, 2005 I revised the assumptions and the formulas in the spreadsheet to accomplish the following:"]
[null,"a.  We distinguish between gifts that go to pay annual expenses from those that go to the Endowment.  "]
[null,null,"Most, if not all, should go to the Endowment from where it may be withdrawn if necessary"]
[null,"b.  Capital Expenses and Expansion Planning shall be paid from endowment if withdrawal category"]
[null,"c.  Operating surplus/deficit shall be $0 every year"]
[null,"d.  Endowment withdrawal for operating budget equals what it is necessary to bring surplus/deficit to zero"]
[null,"e.  Special withdrawals and investment management fees come from Endowment and are not annual operating costs"]
[]
[null,"Note: On August 15, 2005, I completed the Results Page by figuring in Base Cases, Options I and II for one and three-year periods"]
[null,"a. I then developed a two summary tables of important ratios, for base cases (top) and for options I and II (bottom)"]
[null,"b. I also inserted assumptions for growth rates for Options I and II"]
[null,"c. We need to obtain figures for school costs and revenues, weather costs and revenues and shop sales and costs."]
[]
[null,"Note: On August 16, 2005 I arranged for a meeting at the museum on August 18 (Director and Treasurer)."]
[null,"a. I also concentrated all assumptions to the Assumptions page, and made small changes to make model more efficient"]
[null,"b. I conducted an XLAnalyst audit report, finding the \"Risk %\" to be 20%, primarily because I have some denominators that equal 0."]
[]
[null,"Note: On August 17, 2005 I made minor changes, added the log sheet, and sent package to Director and Treasurer"]
[]
[null,"Note: On August 29, after a meeting with Director and Treasurer, I made several corrections- most of them insuring that the same range "]
[null,null,"of revenues and costs were used in the assumptions, results and model sheets.  One must be very careful in playing with"]
[null,null,"the formulas!!  This cannot be overemphasized.  Director will provide growth rates for the subprograms that must be incorporated."]
[]
[null,"Note: On September 15-17, 2005 I incorporated changes identified during past two weeks, including first thoughts on capital campaign"]
[null,null,"submodel.  Completed draft of capital campaign model and added flexibility on assumptions on museum sales, admissions, etc."]
[]
[null,"Note: On September 29 and October 14, 2005 respectively, I met with the Board and Finance Committee of the Museum to present the model and"]
[null,null,"discuss it use sand possible modifications."]
[null,"In late October, I had KS perform an audit of the model and her found errors and 'poor practices' were addressed and "]
[null,null,"became version 4.0.  On November 24, I began modifying the format with protected cells and color coding to make it easier to use."]
[null,"On December 12, I inserted the influence diagram below."]
[null,"On December 29, I received and entered some refinements for 2006 budget from Director."]

{"sheet":"5.7","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
[]
[]
[]
[null,"OVERVIEW"]
[]
[]
[null,"INSTRUCTIONS"]
[]
[]
[null,"LOG OF USE"]
[]
[]
[null,"GUIDE TO SHEETS"]
[]
[]
[null,"INFLUENCE CHART"]
[]
[]
[null,"HISTORICAL DATA","ASSUMPTIONS","Note: the arrows below depict the flow of "]
[null,null,null,"information from one sheet to another."]
[]
[null,null,null,"LONG TERM MODEL",null,"RATIO CHARTS"]
[]
[]
[null,null,null,"SHORT TERM RESULTS"]

{"sheet":"Influence chart","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]

{"sheet":"Assumptions","index":5,"n_rows":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
["BRL 10/04",null,"Revised 5/3/05, 8/15/05, 8/16/05, 9/15/05, 11/24/05, 12/16/05, 12/29/05"]
[null,null,"Note: Assumptions and Projected Data in Italics"]
["Parameters of the Basic Model and Assumptions",null,null,null,null,"Assumptions"]
[null,null,null,"Est"]
["CURRENT MUSEUM OPERATIONS",2003,2004,2005,2006,"Annual","Option","Option","CURRENT MUSEUM OPERATIONS"]
[null,"Actual","Actual","Actual","Proj.","Growth Rate","I","II"]
["Revenues",null,null,null,null,null,null,null,"Revenues"]
["          Grants",null,null,null,null,null,null,null,"          Grants"]
["               Municipal",55000,61664,65000,65000,0.02,0.01,0.03,"               Municipal"]
["               Federal",75000,91024,131500,130400,0.02,0.01,2.5000000000000001E-2,"               Federal"]
["               Foundations",70000,24000,62500,110000,0.05,0.03,0.06,"               Foundations"]
["               Total grants",{"$f":"SUM(B11:B13)","v":200000},{"$f":"SUM(C11:C13)","v":176688},{"$f":"SUM(D11:D13)","v":259000},{"$f":"SUM(E11:E13)","v":305400},null,null,null,"               Total grants"]
["         Sponsorships",15000,2500,15500,25000,0.05,0.03,0.06,"         Sponsorships"]
["         Admissions",66000,63836,60000,63000,0.01,0,0.02,"         Admissions"]
["         Gross Retail Sales",56000,53230,59500,62000,7.0000000000000007E-2,0.05,0.08,"         Gross Retail Sales"]
["         Public programs & events",64406,56725,46126,61100,0.03,0.02,0.05,"         Public programs & events"]
["         Fees for Services",107625,{"$f":"SUM(C20:C21)","v":97017},{"$f":"SUM(D20:D21)","v":118194},{"$f":"SUM(E20:E21)","v":133000},null,null,null,"         Fees for Services"]
["            Weather Services",null,31196,36000,52000,0.03,0.02,0.04,"            Weather Services"]
["            School (contract/non-contract)",null,65821,82194,81000,0.03,0.02,0.04,"            School (contract/non-contract)"]
["         Annual Fund",65000,63000,80000,85000,0.01,0,0.02,"         Annual Fund"]
["         Contributions and membership",49000,32500,34000,38500,0.05,0.03,0.06,"         Contributions and membership"]
["         Gift allocated to Annual Budget",null,60000,55500,7000,null,null,null,"         Gift allocated to Annual Budget"]
["         Endowment withdrawal",146000,{"$f":"C56","v":137156},75000,{"$f":"E56","v":71106}," ",null,null,"         Endowment withdrawal"]
["     Total revenues",{"$f":"SUM(B14:B25)","v":769031},{"$f":"SUM(C14:C25)-C19","v":742652},{"$f":"SUM(D14:D25)-D19","v":802820},{"$f":"SUM(E14:E25)-E19","v":851106},null,null,null,"     Total revenues"]
[]
["Costs",null,null,null,null,null,null,null,"Costs"]
["          Non-Personnel",null,256568,267299,284599,2.75E-2,2.5000000000000001E-2,0.03,"          Non-Personnel"]
["          Personnel",489722,486084,525042,566505,0.04,0.03,0.05,"          Personnel"]
["             Temporary Staff Positions",null,null,null,null,null,null,null,"             Temporary Staff Positions"]
["             Permanent Staff Positions",null,null,null,null,null,null,null,"             Permanent Staff Positions"]
["          Programs",140160,{"$f":"SUM(C34:C40)","v":444084},{"$f":"SUM(D34:D40)","v":445659},{"$f":"SUM(E34:E40)","v":529699},null,null,null,"          Programs"]
["             Weather Services",null,49412,60323,60883,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Weather Services"]
["             School (contract/non-contract)",null,70848,67709,79200,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             School (contract/non-contract)"]
["             Museum Shop Costs",null,40424,45619,47716,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Museum Shop Costs"]
["             Collections, Kitchel",null,51693,81789,91090,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Collections, Kitchel"]
["             Planetarium and Oth. Programs",null,69365,49700,151266,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Planetarium and Oth. Programs"]
["             Exhibits and Planning",null,117316,93859,75778,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Exhibits and Planning"]
["             Auction, Visitor Services",null,45026,46660,23766,0.03,3.5000000000000003E-2,2.5000000000000001E-2,"             Festival, Auction, Visitor, etc."]
["          Facilities and Equipment",68700,88687,103087,116074,0.02,2.5000000000000001E-2,1.7500000000000002E-2,"          Facilities and Equipment"]
["          Administration",56967,131739,118631,91592,0.02,2.5000000000000001E-2,1.7500000000000002E-2,"          Administration"]
["          Development and Marketing",34300,78142,91909,113741,0.08,0.1,0.06,"          Development and Marketing"]
["     Total costs",{"$f":"SUM(B30:B43)","v":789849},{"$f":"SUM(C34:C43)","v":742652},{"$f":"SUM(D34:D43)","v":759286},{"$f":"SUM(E34:E43)","v":851106},null,null,null,"     Total costs"]
["     Capital Expense",null,11194,null,72100,null,null,null,"     Capital Expense"]
["     Expansion Planning",null,46581,null,null,null,null,null,"     Expansion Planning"]
[]
["Operating surplus/deficit",{"$f":"B26-B44","v":-20818},{"$f":"C26-C44","v":0},null,{"$f":"E26-E44","v":0},null,null,null,"Operating surplus/deficit"]
[null,null,null,null,null," "]
["Check [non-personnel+personnel=total costs?]",null,{"$f":"SUM(C29:C30)-C44","v":0},null,{"$f":"SUM(E29:E30)-E44","v":-2}]
[]
["Endowment",null,null,null,null,2007,2008,2009,2010,2011]
["       Beginning of year",null,{"$f":"B58","v":1654000},{"$f":"C58","v":1684667},{"$f":"D58","v":1823127.6900000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Endowment"]
["          Contributions from Capital Campaign",null,52043,52000,80000,253600,356160,263696,12217.6,97330.559999999998,null,null,null,null,null,null,null,null,null,null,"          Beginning of year"]
["          Interest to Investment Income",null,{"$f":"C53*$F$62","v":132320},{"$f":"D53*$F$62","v":134773.36000000002},{"$f":"E53*$F$62","v":145850.21520000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Add. Endowment Contrib."]
["          Withdrawal for operations",null,{"$f":"C44-(SUM(C14:C24)-C19)","v":137156},{"$f":"D44-(SUM(D14:D24)-D19)","v":31466},{"$f":"E44-(SUM(E14:E24)-E19)","v":71106},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Interest to Investment Income"]
["          Investment Management Fee",null,{"$f":"C53*$E$63","v":16540},{"$f":"D53*$E$63","v":16846.670000000002},{"$f":"E53*$E$63","v":18231.276900000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Special withdrawal"]
["       End of year",1654000,{"$f":"SUM(C53:C55)-SUM(C56:C57)","v":1684667},{"$f":"SUM(D53:D55)-SUM(D56:D57)","v":1823127.6900000002},{"$f":"SUM(E53:E55)-SUM(E56:E57)","v":1959640.6283000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          Investment Management Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"          End of year"]
["Other Model Assumptions:   "]
[null,null,null,"Limit on Endowment Withdrawal for Operations",0.04]
[null,null,null,"Interest on Investment Income",null,0.08,0.05,0.1]
[null,null,null,"Investment Management Fee",0.01]
[null,null,null,"Growth rate of Museum paid attendance "]
[null,null,null,"Growth rate of admissions fee"]
[null,null,null,"Sales in Museum Shop per paid admission"]
[null,null,null,"Growth rate of museum shop sales per admission"]
[null,null,null,"Growth rate for weather service fees"]
[null,null,null,"Growth rate for school service fees"]
[null,null,null,"% of Capital Campaign to Endowment",0.4]
[]
["Notes of Symbols and Comments"]
[null,"A cell marked with this symbol has a pertinent comment attached to it"]

{"sheet":"5.8 Long-term Model","index":6,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
["SGP",null,null,null,null,"Note: Assumptions and Projected Data in Italics"]
["2003-12-17","with add. data -1-7-04",null,null,null,"BRL made adjustments on 10-26-04 and on 11-17-04 and 1-13-05 and 5-03-05 and 8-15-05 and 8/29/05 and 9/12-16/05, 11/24/05 and 12/29/05"]
[null,"Basic Business Planning Model"]
[null,null,null,"Est",null,null,null,"Three-Year Horizon"]
["CURRENT MUSEUM OPERATIONS",2003,2004,2005,2006,"Annual"]
[null,"Actual","Actual","Actual","Projected","Growth rate",{"$f":"E7+1","v":2007},{"$f":"G8+1","v":2008},{"$f":"H8+1","v":2009},2010,2011,2012,2013,2014,2015,2016," "]
["Revenues"]
["          Grants"]
["               Municipal",55000,{"$f":"Assumptions!C11","v":61664},65000,{"$f":"Assumptions!E11","v":65000},{"$f":"Assumptions!F11","v":0.02},{"$f":"$E11*(1+$F11)","v":66300},{"$f":"G11*(1+$F11)","v":67626},{"$f":"H11*(1+$F11)","v":68978.52},70358.090400000001,71765.252208000005,73200.557252160012,74664.568397203213,76157.859765147281,77681.01696045023,79234.63729965924]
["               Federal",75000,{"$f":"Assumptions!C12","v":91024},131500,{"$f":"Assumptions!E12","v":130400},{"$f":"Assumptions!F12","v":0.02},{"$f":"$E12*(1+$F12)","v":133008},{"$f":"G12*(1+$F12)","v":135668.16},138381.5232,141149.15366400001,143972.13673728,146851.57947202559,149788.6110614661,152784.38328269543,155840.07094834934,158956.87236731633]
["               Foundations",70000,{"$f":"Assumptions!C13","v":24000},62500,{"$f":"Assumptions!E13","v":110000},{"$f":"Assumptions!F13","v":0.05},{"$f":"$E13*(1+$F13)","v":115500},{"$f":"G13*(1+$F13)","v":121275},127338.75,133705.6875,140390.97187500002,147410.52046875004,154781.04649218754,162520.09881679693,170646.1037576368,179178.40894551863]
["               Total grants",{"$f":"SUM(B11:B13)","v":200000},{"$f":"Assumptions!C14","v":176688},{"$f":"SUM(D11:D13)","v":259000},{"$f":"Assumptions!E14","v":305400},"xxx",{"$f":"SUM(G11:G13)","v":314808},324569.16000000003,334698.79320000001,345212.93156400003,356128.36082028004,367462.65719293564,379234.22595085687,391462.34186463966,404167.19166643638,417369.91861249425]
["         Sponsorships",15000,{"$f":"Assumptions!C15","v":2500},15500,{"$f":"Assumptions!E15","v":25000},{"$f":"Assumptions!F15","v":0.05},{"$f":"$E15*(1+$F15)","v":26250},{"$f":"G15*(1+$F15)","v":27562.5},{"$f":"H15*(1+$F15)","v":28940.625},{"$f":"I15*(1+$F15)","v":30387.65625},{"$f":"J15*(1+$F15)","v":31907.0390625},33502.391015624999,35177.51056640625,36936.386094726564,38783.205399462895,40722.36566943604]
["         Admissions",66000,{"$f":"Assumptions!C16","v":63836},60000,{"$f":"Assumptions!E16","v":63000},{"$f":"Assumptions!F16","v":0.01},{"$f":"$E16*(1+$F16)","v":63630},{"$f":"G16*(1+$F16)","v":64266.3},{"$f":"H16*(1+$F16)","v":64908.963000000003},65558.052630000006,66213.633156300013,66875.769487863014,67544.527182741644,68219.972454569055,68902.172179114743,69591.193900905884]
["         Gross Retail Sales",56000,{"$f":"Assumptions!C17","v":53230},59500,{"$f":"Assumptions!E17","v":62000},{"$f":"Assumptions!F17","v":7.0000000000000007E-2},{"$f":"$E17*(1+$F17)","v":66340},{"$f":"G17*(1+$F17)","v":70983.8},75952.666000000012,81269.35262000002,86958.20730340002,93045.28181463803,99558.451541662696,106527.5431495791,113984.47117004964,121963.38415195313]
["         Public programs & events",64406,{"$f":"Assumptions!C18","v":56725},46126,{"$f":"Assumptions!E18","v":61100},{"$f":"Assumptions!F18","v":0.03},{"$f":"$E18*(1+$F18)","v":62933},{"$f":"G18*(1+$F18)","v":64820.990000000005},66765.61970000001,68768.588291000007,70831.645939730006,72956.595317921907,75145.293177459564,77399.651972783351,79721.641531966859,82113.290777925868]
["         Fees for Services",107625,{"$f":"Assumptions!C19","v":97017},{"$f":"SUM(D20:D21)","v":118194},{"$f":"Assumptions!E19","v":133000},"xxx",{"$f":"SUM(G20:G21)","v":136990},{"$f":"SUM(H20:H21)","v":141099.70000000001},145332.69100000002,149692.67173000003,154183.45188190002,158808.95543835702,163573.22410150775,168480.420824553,173534.83344928958,178740.87845276826]
["            Weather Services",null,{"$f":"Assumptions!C20","v":31196},36000,{"$f":"Assumptions!E20","v":52000},{"$f":"Assumptions!F20","v":0.03},{"$f":"$E20*(1+$F20)","v":53560},{"$f":"G20*(1+$F$20)","v":55166.8},{"$f":"H20*(1+$F$20)","v":56821.804000000004},{"$f":"I20*(1+$F$20)","v":58526.458120000003},60282.251863600002,62090.719419508001,63953.441002093241,65872.04423215604,67848.205559120717,69883.651725894335]
["            School (contract/non-contract)",null,{"$f":"Assumptions!C21","v":65821},82194,{"$f":"Assumptions!E21","v":81000},{"$f":"Assumptions!F21","v":0.03},{"$f":"$E21*(1+$F21)","v":83430},{"$f":"G21*(1+$F$21)","v":85932.900000000009},{"$f":"H21*(1+$F$21)","v":88510.887000000017},91166.213610000021,93901.20001830002,96718.236018849027,99619.783099414504,102608.37659239695,105686.62789016886,108857.22672687394]
["         Annual Fund",65000,{"$f":"Assumptions!C22","v":63000},80000,{"$f":"Assumptions!E22","v":85000},{"$f":"Assumptions!F22","v":0.01},{"$f":"$E22*(1+$F22)","v":85850},{"$f":"G22*(1+$F22)","v":86708.5},{"$f":"H22*(1+$F22)","v":87575.585000000006},{"$f":"I22*(1+$F22)","v":88451.340850000008},89335.85425850001,90229.212801085014,91131.50492909587,92042.819978386833,92963.248178170703,93892.88065995241]
["         Contributions and membership",49000,{"$f":"Assumptions!C23","v":32500},34000,{"$f":"Assumptions!E23","v":38500},{"$f":"Assumptions!F23","v":0.05},{"$f":"$E23*(1+$F23)","v":40425},{"$f":"G23*(1+$F23)","v":42446.25},{"$f":"H23*(1+$F23)","v":44568.5625},46796.990624999999,49136.84015625,51593.682164062506,54173.36627226563,56882.034585878915,59726.136315172866,62712.443130931511]
["         Gifts allocated to annual budget",null,{"$f":"Assumptions!C24","v":60000},55500,{"$f":"Assumptions!E24","v":7000},null,{"$f":"E24*(1+$F$24)","v":7000},{"$f":"G24*(1+$F$24)","v":7000},{"$f":"H24*(1+$F$24)","v":7000},7000,7000,7000,7000,7000,7000,7000]
["         Endowment withdrawal",146000,{"$f":"Assumptions!C25","v":137156},75000,{"$f":"Assumptions!E25","v":71106},"xxx",{"$f":"G56","v":76023.569999999949},{"$f":"H56","v":81223.67790000001},86730.616893000086,92571.038326109992,98774.174164415803,105372.07951147819,112399.89693299867,119896.14447871048,127903.02945850964,136466.79020327004]
["     Total revenues",{"$f":"SUM(B14:B25)","v":769031},{"$f":"Assumptions!C26","v":742652},{"$f":"SUM(D14:D25)-D19","v":802820},{"$f":"Assumptions!E26","v":851106},"xxx",{"$f":"SUM(G14:G25)-G19","v":880249.57},{"$f":"SUM(H14:H25)-H19","v":910680.87789999996},942474.12229300023,975708.6228861101,1010469.2067432757,1046846.6247439662,1084938.000654995,1124847.315403827,1166685.9293481731,1210573.1455596373]
[]
["Costs"]
["          Non-Personnel",null,{"$f":"Assumptions!C29","v":256568},231164,{"$f":"Assumptions!E29","v":284599},{"$f":"Assumptions!F29","v":2.75E-2},{"$f":"$E29*(1+$F29)","v":292425.47250000003},{"$f":"G29*(1+$F29)","v":300467.17299375008},308730.02025107824,317220.0958079829,325943.64844270243,334907.09877487679,344117.04399118596,353580.26270094363,363303.7199252196,373294.57222316315]
["          Personnel",489722,{"$f":"Assumptions!C30","v":486084},540000,{"$f":"Assumptions!E30","v":566505},{"$f":"Assumptions!F30","v":0.04},{"$f":"$E30*(1+$F30)","v":589165.20000000007},612731.80800000008,637241.08032000007,662730.7235328001,689239.95247411216,716809.5505730767,745481.9325959998,775301.20989983983,806313.25829583348,838565.78862766689]
["             Temporary Staff Positions",null,{"$f":"Assumptions!C31","v":0},null,{"$f":"Assumptions!E31","v":0},null,{"$f":"$E31*(1+$F31)","v":0},0,0,0,0,0,0,0,0,0]
["             Permanent Staff Positions",null,null,null,{"$f":"Assumptions!E32","v":0},null,{"$f":"$E32*(1+$F32)","v":0},0,0,0,0,0,0,0,0,0]
["          Programs",140160,null,{"$f":"Assumptions!D33","v":445659},{"$f":"SUM(E34:E40)","v":529699},"xxx",{"$f":"SUM(G34:G40)","v":545589.97},{"$f":"SUM(H34:H40)","v":561957.66909999994},{"$f":"SUM(I34:I40)","v":578816.39917300013},{"$f":"SUM(J34:J40)","v":596180.89114819001},614066.31788263575,632488.30741911486,651462.95664168824,671006.84534093889,691137.0507011672,711871.16222220205]
["             Weather Services",null,{"$f":"Assumptions!C34","v":49412},{"$f":"Assumptions!D34","v":60323},{"$f":"Assumptions!E34","v":60883},{"$f":"Assumptions!F34","v":0.03},{"$f":"$E34*(1+$F34)","v":62709.490000000005},64590.774700000009,66528.497941000009,68524.352879230006,70580.083465606906,72697.485969575107,74878.410548662359,77124.762865122233,79438.505751075907,81821.660923608186]
["             School (contract/non-contract)",null,{"$f":"Assumptions!C35","v":70848},{"$f":"Assumptions!D35","v":67709},{"$f":"Assumptions!E35","v":79200},{"$f":"Assumptions!F35","v":0.03},81576,84023.28,86543.978400000007,89140.297752000013,91814.506684560023,94568.941885096821,97406.010141649735,100328.19044589924,103338.03615927622,106438.1772440545]
["             Museum Shop Costs",null,{"$f":"Assumptions!C36","v":40424},{"$f":"Assumptions!D36","v":45619},{"$f":"Assumptions!E36","v":47716},{"$f":"Assumptions!F36","v":0.03},49147.48,50621.904400000007,52140.561532000007,53704.778377960007,55315.921729298811,56975.399381177776,58684.661362613115,60445.20120349151,62258.557239596259,64126.31395678415]
["             Collections, Kitchel",null,{"$f":"Assumptions!C37","v":51693},{"$f":"Assumptions!D37","v":81789},{"$f":"Assumptions!E37","v":91090},{"$f":"Assumptions!F37","v":0.03},93822.7,96637.380999999994,99536.502429999993,102522.5975029,105598.275427987,108766.22369082661,112029.21040155141,115390.08671359795,118851.7893150059,122417.34299445608]
["             Planetarium and Oth. Programs",null,{"$f":"Assumptions!C38","v":69365},{"$f":"Assumptions!D38","v":49700},{"$f":"Assumptions!E38","v":151266},{"$f":"Assumptions!F38","v":0.03},155803.98000000001,160478.09940000001,165292.44238200001,170251.21565346001,175358.75212306381,180619.51468675572,186038.1001273584,191619.24313117916,197367.82042511454,203288.85503786796]
["             Exhibits and Planning",null,{"$f":"Assumptions!C39","v":117316},{"$f":"Assumptions!D39","v":93859},{"$f":"Assumptions!E39","v":75778},{"$f":"Assumptions!F39","v":0.03},78051.34,80392.8802,82804.666605999999,85288.806604180005,87847.470802305412,90482.894926374574,93197.381774165813,95993.303227390788,98873.102324212508,101839.29539393888]
["             Festival, Auction, Visitor, etc.",null,{"$f":"Assumptions!C40","v":45026},{"$f":"Assumptions!D40","v":46660},{"$f":"Assumptions!E40","v":23766},{"$f":"Assumptions!F40","v":0.03},24478.98,25213.349399999999,25969.749882,26748.842378460002,27551.307649813803,28377.846879308217,29229.182285687464,30106.05775425809,31009.239486885836,31939.516671492413]
["          Facilities and Equipment",68700,{"$f":"Assumptions!C41","v":88687},{"$f":"Assumptions!D41","v":103087},{"$f":"Assumptions!E41","v":116074},{"$f":"Assumptions!F41","v":0.02},118395.48,120763.38959999999,123178.65739199999,125642.23053983999,128155.0751506368,130718.17665364953,133332.54018672253,135999.19099045699,138719.17481026612,141493.55830647144]
["          Administration",56967,{"$f":"Assumptions!C42","v":131739},{"$f":"Assumptions!D42","v":118631},{"$f":"Assumptions!E42","v":91592},{"$f":"Assumptions!F42","v":0.02},{"$f":"$E42*(1+$F42)","v":93423.84},95292.316800000001,97198.163136000003,99142.126398720007,101124.9689266944,103147.46830522829,105210.41767133286,107314.62602475952,109460.91854525471,111650.13691615981]
["          Development and Marketing",34300,{"$f":"Assumptions!C43","v":78142},{"$f":"Assumptions!D43","v":91909},{"$f":"Assumptions!E43","v":113741},{"$f":"Assumptions!F43","v":0.08},{"$f":"E43*(1+$F$43)","v":122840.28000000001},{"$f":"G43*(1+$F$43)","v":132667.50240000003},143280.90259200003,154743.37479936003,167122.84478330883,180492.67236597356,194932.08615525145,210526.65304767157,227368.78529148531,245558.28811480416]
["     Total Costs",{"$f":"SUM(B30:B43)","v":789849},{"$f":"Assumptions!C44","v":742652},{"$f":"Assumptions!D44","v":759286},{"$f":"Assumptions!E44","v":851106},"xxx",{"$f":"SUM(G34:G43)","v":880249.57},910680.87789999996,942474.12229300011,975708.62288610998,1010469.2067432757,1046846.6247439663,1084938.000654995,1124847.315403827,1166685.9293481733,1210573.1455596373]
["          Capital Expense",null,{"$f":"Assumptions!C45","v":11194},{"$f":"Assumptions!D45","v":0},{"$f":"Assumptions!E45","v":72100}]
["          Expansion Planning",null,{"$f":"Assumptions!C46","v":46581},{"$f":"Assumptions!D46","v":0},{"$f":"Assumptions!E46","v":0}]
[]
["Operating surplus/deficit",{"$f":"B26-B44","v":-20818},{"$f":"Assumptions!C48","v":0},null,{"$f":"Assumptions!E48","v":0},"xxx",{"$f":"G26-G44","v":0},0,0,0,0,0,0,0,0,0]
[]
["Check [(non-personnel+personnel)-total costs?]",null,null,null,null,null,{"$f":"SUM(G29:G30)-G44","v":1341.1025000001537},2518.1030937501928,3496.9782780781388,4242.1964546729578,4714.394173538778,4870.0246039872291,4660.9759321906604,4034.1571969564538,2931.0488728797063,1287.2152911927551]
[null,null,null,null,null," "]
["Endowment"]
["       Beginning of year",null,{"$f":"Assumptions!C53","v":1654000},{"$f":"Assumptions!D53","v":1684667},{"$f":"Assumptions!E53","v":1823127.6900000002},"xxx",{"$f":"E58","v":1959640.6283000002},{"$f":"G58","v":2274391.9022810003},{"$f":"H58","v":2708535.6575406701},3075098.536675517,3210001.9959166935,3433258.5214664461,3568214.538457619,3705589.6592166536,3845084.7908831085,3986337.6967864167]
["          Contributions from Capital Campaign",null,{"$f":"Assumptions!C54","v":52043},{"$f":"Assumptions!D54","v":52000},{"$f":"Assumptions!E54","v":80000},{"$f":"Assumptions!E54","v":80000},{"$f":"Assumptions!F54","v":253600},{"$f":"Assumptions!G54","v":356160},{"$f":"Assumptions!H54","v":263696},{"$f":"Assumptions!I54","v":12217.6},{"$f":"Assumptions!J54","v":97330.559999999998},0,0,0,0,0]
["          Interest to Investment Income",null,{"$f":"Assumptions!C55","v":132320},{"$f":"Assumptions!D55","v":134773.36000000002},{"$f":"Assumptions!E55","v":145850.21520000001},{"$f":"Assumptions!F62","v":0.08},{"$f":"G$53*($F55)","v":156771.25026400003},{"$f":"H$53*($F55)","v":181951.35218248001},{"$f":"I$53*($F55)","v":216682.85260325362},{"$f":"J$53*($F55)","v":246007.88293404135},256800.1596733355,274660.68171731569,285457.16307660955,296447.17273733229,307606.78327064868,318907.01574291335]
["          Withdrawal for operations",null,{"$f":"Assumptions!C56","v":137156},{"$f":"Assumptions!D56","v":31466},{"$f":"Assumptions!E56","v":71106},null,{"$f":"SUM(G44:G46)-(SUM(G14:G24)-G19)","v":76023.569999999949},{"$f":"SUM(H44:H46)-(SUM(H14:H24)-H19)","v":81223.67790000001},86730.616893000086,92571.038326109992,98774.174164415803,105372.07951147819,112399.89693299867,119896.14447871048,127903.02945850964,136466.79020327004]
["          Investment Management Fee",null,{"$f":"Assumptions!C57","v":16540},{"$f":"Assumptions!D57","v":16846.670000000002},{"$f":"Assumptions!E57","v":18231.276900000001},"xxx",{"$f":"Assumptions!$E$63*G53","v":19596.406283000004},{"$f":"Assumptions!$E$63*H53","v":22743.919022810001},{"$f":"Assumptions!$E$63*I53","v":27085.356575406702},{"$f":"Assumptions!$E$63*J53","v":30750.985366755169},{"$f":"Assumptions!$E$63*K53","v":32100.019959166937},{"$f":"Assumptions!$E$63*L53","v":34332.585214664461},{"$f":"Assumptions!$E$63*M53","v":35682.145384576193},{"$f":"Assumptions!$E$63*N53","v":37055.896592166537},{"$f":"Assumptions!$E$63*O53","v":38450.847908831085},{"$f":"Assumptions!$E$63*P53","v":39863.376967864169}]
["       End of year",1654000,{"$f":"Assumptions!C58","v":1684667},{"$f":"Assumptions!D58","v":1823127.6900000002},{"$f":"Assumptions!E58","v":1959640.6283000002},"xxx",{"$f":"SUM(G53:G55)-SUM(G56:G57)","v":2274391.9022810003},2708535.6575406701,3075098.536675517,3210001.9959166935,3433258.5214664461,3568214.538457619,3705589.6592166536,3845084.7908831085,3986337.6967864167,4128914.5453581954]
[]
[]
["Ratios"]
["  General Admission Revenues/Total Expenditures",{"$f":"B16/B44","v":8.3560275445053428E-2},{"$f":"C16/C44","v":8.5956814227929099E-2},{"$f":"D16/D44","v":7.9021607141446043E-2},{"$f":"E16/E44","v":7.4021332242987362E-2},"A",{"$f":"G16/G44","v":7.2286317617854673E-2},7.0569506354625527E-2,6.8870817208306165E-2,6.7190194994978844E-2,6.5527611048836781E-2,6.3883063580798413E-2,6.2256577926078631E-2,6.0648206668011358E-2,5.9058029625513993E-2,5.7486153691881613E-2]
["  Municipal Appropriations/Total Expenditures",{"$f":"B11/B44","v":6.9633562870877852E-2},{"$f":"C11/C44","v":8.3032160419685128E-2},{"$f":"D11/D44","v":8.5606741069899878E-2},{"$f":"E11/E44","v":7.6371215806256804E-2},"B",{"$f":"G11/G44","v":7.5319548295831609E-2},7.4258724039471785E-2,7.3188768124665488E-2,7.2109735170612074E-2,7.1021711229873233E-2,6.992481565297412E-2,6.8819202896503742E-2,6.7705064253814881E-2,6.6582629486112488E-2,6.5452168330588367E-2]
["  Foundation Grants/Total Expenditures",{"$f":"B13/B44","v":8.8624534562935453E-2},{"$f":"C13/C44","v":3.2316616665679213E-2},{"$f":"D13/D44","v":8.231417410567296E-2},{"$f":"E13/E44","v":0.12924359597981919},"C",{"$f":"G13/G44","v":0.13121278775518175},0.13316959095446931,0.13511113672828506,0.13703444282833488,0.13893641779295543,0.14081386612370569,0.14266349450267543,0.14448191909357158,0.14626567396160908,0.14801122063771374]
["  Government Grants/Total Expenditures",{"$f":"B12/B44","v":9.4954858460287977E-2},{"$f":"C12/C44","v":0.12256615480736603},{"$f":"D12/D44","v":0.17318902231833591},{"$f":"E12/E44","v":0.1532124083251675},"D",{"$f":"G12/G44","v":0.15110260150425295},0.14897442484226342,0.14682792866855965,0.1446632225576587,0.14248047914423798,0.14027993786381265,0.13806190858006287,0.13582677505688398,0.13357499823060101,0.13130711923551877]
["  Weather Services Revenues/Weather Services Costs",null,{"$f":"C20/C34","v":0.63134461264470165},0.59678729506158512,0.85409720283166068,"E",{"$f":"G20/G34","v":0.85409720283166068},{"$f":"H20/H34","v":0.85409720283166068},0.85409720283166068,0.85409720283166068,0.85409720283166068,0.85409720283166068,0.8540972028316608,0.8540972028316608,0.85409720283166057,0.85409720283166057]
["  School ServicesRevenues/Cost of School Programs",null,0.92904528003613374,1.2139302013026334,1.0227272727272727,"F",{"$f":"G21/G35","v":1.0227272727272727},1.0227272727272729,1.0227272727272729,1.0227272727272727,1.0227272727272727,1.0227272727272727,1.0227272727272727,1.0227272727272727,1.0227272727272727,1.0227272727272729]
["  Shop Sales/Shop Costs",null,{"$f":"C17/C36","v":1.3167920047496537},{"$f":"D17/D36","v":1.3042811109406169},{"$f":"E17/E36","v":1.2993545142090703},"G",{"$f":"G17/G36","v":1.3498148836929176},{"$f":"H17/H36","v":1.4022348791761376},1.456690602639289,1.5132611114796497,1.5720285332846846,1.6330781850627307,1.6964986971040017,1.76238214165173,1.8308241665702438,1.9019241342040398]
["  Development and Marketing Costs/Total Revenues",{"$f":"B43/B26","v":4.4601583031113182E-2},{"$f":"C43/C26","v":0.10522021081206272},{"$f":"D43/D26","v":0.11448269848783039},{"$f":"E43/E26","v":0.13363905318491467},"H",{"$f":"G43/G26","v":0.13955165010759393},0.14567946425527997,0.15202635192083955,0.15859588730663754,0.16539132876888232,0.1724155841932602,0.17967117571471156,0.18716020402474912,0.19488431254032193,0.20284465173831748]
["  Administration Costs/Total Revenues",{"$f":"B42/B26","v":7.4076337624881181E-2},{"$f":"C42/C26","v":0.17738994845499642},{"$f":"D42/D26","v":0.14776786826436811},{"$f":"E42/E26","v":0.10761526766348728},"I",{"$f":"G42/G26","v":0.10613335488479705},0.10463853926497385,0.10313085615499015,0.10161038251918002,0.10007723961486999,9.8531595619803153E-2,9.6973668179947237E-2,9.54037268482371E-2,9.3822095382954065E-2,9.2229153872849981E-2]

{"sheet":"Short-Term Results","index":7,"n_rows":58,"n_cols":26,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
["BRL 10-26-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual"]
["Summary of the Model Outputs - Decision Variables, Base Case",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth Rate",null,null,null,null,"One-Year",null,null,"Three-Year"]
[null,null,null,null,null,null,null,null,null,null,null,"Assumptions for Base Case and Options",null,null,null,"Base",null,null,null,"Base Year","Base",null,null,"Base"]
["Decision Variables and Summary (Base Case)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case","Option I","Option II",null,"2006 proj","Case","Option I","Option II","Case","Option I","Option II"]
[null,null,null,null,null,null,null,null,null,null,null,"CURRENT MUSEUM OPERATIONS"]
["Important Ratios and Factors",null,null,"GOAL",null,"End of Year One - 2007",null,null,"End of Year Three - 2009"]
[null,null,null,null,"Base Case","Option I ","Option II","Base Case","Option I ","Option II",null,"Revenues"]
[null,null,null,null,null,null,null,null,null,null,null,"          Grants"]
["Operating surplus/deficit",null,null,0,{"$f":"U49","v":0},0,0,0,0,0,null,"               Municipal",null,null,null,{"$f":"Assumptions!F11","v":0.02},{"$f":"Assumptions!G11","v":0.01},{"$f":"Assumptions!H11","v":0.03},null,{"$f":"Assumptions!E11","v":65000},{"$f":"(1+P11)*$T11","v":66300},65650,66950,{"$f":"POWER(1+P11,3)*$T11","v":68978.51999999999},66969.564999999988,71027.255000000005]
["Grants as % of Revenues",null,null,0.33,{"$f":"U14/U26","v":0.35763493755526632},0.35054171594973554,0.36260565743700135,0.35512783352151017,0.33411366675354293,0.37037092418002754,null,"               Federal",null,null,null,{"$f":"Assumptions!F12","v":0.02},{"$f":"Assumptions!G12","v":0.01},{"$f":"Assumptions!H12","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E12","v":130400},133008,131704,133660,138381.5232,134351.25039999999,140426.53749999998]
["Endowment, end of year ",null,null,"xxx",{"$f":"U58","v":2274391.9022810003},2199556.0384320002,2326716.1948470003,3075098.536675517,2941925.6673414223,3171938.0535939867,null,"               Foundations",null,null,null,{"$f":"Assumptions!F13","v":0.05},{"$f":"Assumptions!G13","v":0.03},{"$f":"Assumptions!H13","v":0.06},null,{"$f":"Assumptions!E13","v":110000},115500,113300,116600,127338.75000000001,120199.97,131011.76000000004]
["Personnel as % of Total Costs",null,null,0.67,{"$f":"U30/U44","v":0.66931608952674648},0.65842108531655186,0.67995590890787139,0.67613642141135843,0.64328082779374762,0.70923741137020602,null,"               Total grants",null,null,null,"xxx","xxx","xxx",null,{"$f":"SUM(T11:T13)","v":305400},{"$f":"SUM(U11:U13)","v":314808},310654,317210,334698.79320000001,321520.78539999994,342465.55249999999]
["Endowment Withdrawal as %",null,null,0.06,{"$f":"U25/U26","v":8.6365926881395647E-2},0.10389195424479025,7.1892524327849205E-2,9.2024401351188417E-2,0.14407776671539879,4.7652134146488695E-2,null,"         Sponsorships",null,null,null,{"$f":"Assumptions!F15","v":0.05},{"$f":"Assumptions!G15","v":0.03},{"$f":"Assumptions!H15","v":0.06},null,{"$f":"Assumptions!E15","v":25000},{"$f":"(1+P15)*$T15","v":26250},25750,26500,{"$f":"POWER(1+P15,3)*$T15","v":28940.625000000004},27318.174999999999,29775.400000000009]
["   of Total Revenues",null,null,"xxx",null,null,null,null,null,null,null,"         Admissions",null,null,null,{"$f":"Assumptions!F16","v":0.01},{"$f":"Assumptions!G16","v":0},{"$f":"Assumptions!H16","v":0.02},null,{"$f":"Assumptions!E16","v":63000},63630,63000,64260,64908.962999999996,63000,66856.103999999992]
["Endowment Withdrawal as %",null,null,1,{"$f":"U56/(Assumptions!$E$61*U53)","v":0.96986622064922734},{"$f":"V56/(Assumptions!$E$61*V53)","v":1.1745803499679353},{"$f":"W56/(Assumptions!$E$61*W53)","v":0.80234213727441472},{"$f":"X56/(Assumptions!$E$61*X53)","v":0.80053050669222892},{"$f":"Y56/(Assumptions!$E$61*Y53)","v":1.2797267050451693},{"$f":"Z56/(Assumptions!$E$61*Z53)","v":0.40669404704599588},null,"         Gross Retail Sales",null,null,null,{"$f":"Assumptions!F17","v":7.0000000000000007E-2},{"$f":"Assumptions!G17","v":0.05},{"$f":"Assumptions!H17","v":0.08},null,{"$f":"Assumptions!E17","v":62000},66340,65100,66960,75952.666000000012,71772.750000000015,78102.144000000015]
["   of Maximum Allowed",null,null,"xxx",null,null,null,null,null,null,null,"         Public programs & events",null,null,null,{"$f":"Assumptions!F18","v":0.03},{"$f":"Assumptions!G18","v":0.02},{"$f":"Assumptions!H18","v":0.05},null,{"$f":"Assumptions!E18","v":61100},62933,62322,64155,66765.619699999996,64839.808799999999,70730.887500000012]
["Over or Under Limit ?",null,null,"UNDER",{"$f":"IF(E17>100%,\"OVER\",\"UNDER\")","v":"UNDER"},"OVER","UNDER","UNDER","OVER","UNDER",null,"         Fees for Services",null,null,null,"xxx","xxx","xxx",null,{"$f":"SUM(T20:T21)","v":133000},{"$f":"SUM(U20:U21)","v":136990},135660,138320,145332.69099999999,141140.66399999999,149606.91200000001]
["  General Admission Revenues/Total Expenditures",null,null,0.1,{"$f":"U16/U44","v":7.2286317617854673E-2},7.1089147749049869E-2,7.3456194782326248E-2,6.8870817208306165E-2,6.5467496850277376E-2,7.2303788935256588E-2,null,"            Weather Services",null,null,null,{"$f":"Assumptions!F20","v":0.03},{"$f":"Assumptions!G20","v":0.02},{"$f":"Assumptions!H20","v":0.04},null,{"$f":"Assumptions!E20","v":52000},{"$f":"(1+P20)*$T20","v":53560},53040,54080,{"$f":"POWER(1+P20,3)*$T20","v":56821.804000000004},55182.815999999999,58492.928000000007]
["  Municipal Appropriations/Total Expenditures",null,null,0.08,{"$f":"U11/U44","v":7.5319548295831609E-2},7.407940555119244E-2,7.6531158429454432E-2,7.3188768124665474E-2,6.9592536280983261E-2,7.6814820890111227E-2,null,"            School (contract/non-contract)",null,null,null,{"$f":"Assumptions!F21","v":0.03},{"$f":"Assumptions!G21","v":0.02},{"$f":"Assumptions!H21","v":0.04},null,{"$f":"Assumptions!E21","v":81000},83430,82620,84240,88510.887000000002,85957.847999999998,91113.984000000011]
["  Foundation Grants/Total Expenditures",null,null,0.1,{"$f":"U13/U44","v":0.13121278775518175},0.12784762603122779,0.13328652834763835,0.13511113672828509,0.12490779614886406,0.14168708728639789,null,"         Annual Fund",null,null,null,{"$f":"Assumptions!F22","v":0.01},{"$f":"Assumptions!G22","v":0},{"$f":"Assumptions!H22","v":0.02},null,{"$f":"Assumptions!E22","v":85000},85850,85000,86700,87575.584999999992,85000,90202.68]
["  Government Grants/Total Expenditures",null,null,0.15,{"$f":"U12/U44","v":0.15110260150425295},0.14861468436731531,0.15278797065990857,0.14682792866855965,0.13961333432369566,0.15186901600351846,null,"         Contributions and membership",null,null,null,{"$f":"Assumptions!F23","v":0.05},{"$f":"Assumptions!G23","v":0.03},{"$f":"Assumptions!H23","v":0.06},null,{"$f":"Assumptions!E23","v":38500},40425,39655,40810,44568.562500000007,42069.989500000003,45854.116000000009]
["  Weather Services Revenues/Weather Services Costs",null,null,1.4,{"$f":"U20/U34","v":0.85409720283166068},0.84171898250076715,0.86659618628773383,0.85409720283166091,0.81749812541137312,0.89214556581921522,null,"         Gift allocated to Annual Budget",null,null,null,{"$f":"Assumptions!F24","v":0},{"$f":"Assumptions!G24","v":0},{"$f":"Assumptions!H24","v":0},null,{"$f":"Assumptions!E24","v":7000},{"$f":"$T$24*(1+P24)","v":7000},{"$f":"$T$24*(1+Q24)","v":7000},{"$f":"$T$24*(1+R24)","v":7000},{"$f":"$T$24*(1+P24)^3","v":7000},{"$f":"$T$24*(1+Q24)^3","v":7000},{"$f":"$T$24*(1+R24)^3","v":7000}]
["  School ServicesRevenues/Cost of School Programs",null,null,1.4,1.0227272727272727,1.0079051383399209,1.0376940133037693,1.0227272727272727,0.97890219695101777,1.0682877761231242,null,"         Endowment withdrawal",null,null,null,{"$f":"Assumptions!F25","v":" "},null,null,null,{"$f":"T56","v":71106},{"$f":"U56","v":76023.569999999949},92070.214999999967,62892.089999999967,86730.616893000086,138647.41650087491,44061.81312534411]
["  Shop Sales/Shop costs",null,null,1.4,{"$f":"U17/U36","v":1.3498148836929176},1.3181857390526801,1.3690759759471183,1.456690602639289,1.3566708929548696,1.5199430989598752,null,"     Total revenues",null,null,null,null,null,null,null,{"$f":"SUM(T14:T25)-T19","v":851106},880249.57,886211.21499999997,874807.09,942474.12229300023,962309.58920087491,924655.60912534408]
["  Development and Marketing Costs/Total Costs",null,null,0.14000000000000001,{"$f":"U43/U44","v":0.13955165010759393},0.14117977507201826,0.13781948200717031,0.15202635192083958,0.15731867654536971,0.14650573631856528]
["  Administration Costs/Total Costs",null,null,0.14000000000000001,{"$f":"U42/U44","v":0.10613335488479705},0.1059361452562976,0.10653189836401532,0.10313085615499015,0.10249774836693512,0.10434719702521775,null,"Costs"]
[null,null,null,null,null,null,null,null,null,null,null,"          Non-Personnel",null,null,null,{"$f":"Assumptions!F29","v":2.75E-2},{"$f":"Assumptions!G29","v":2.5000000000000001E-2},{"$f":"Assumptions!H29","v":0.03},null,{"$f":"Assumptions!E29","v":284599},{"$f":"(1+P29)*$T29","v":292425.47250000003},291713.97499999998,293136.97000000003,{"$f":"POWER(1+P29,3)*$T29","v":308730.02025107818},306481.99498437496,310989.01147299999]
[null,null,null,null,null,null,null,null,null,null,null,"          Personnel",null,null,null,{"$f":"Assumptions!F30","v":0.04},{"$f":"Assumptions!G30","v":0.03},{"$f":"Assumptions!H30","v":0.05},null,{"$f":"Assumptions!E30","v":566505},589165.20000000007,583500.15,594830.25,637241.08032000007,619035.30913499999,655800.35062500008]
[null,null,null,null,null,null,null,null,null,null,null,"             Temporary Staff Positions",null,null,null,{"$f":"Assumptions!F31","v":0},{"$f":"Assumptions!G31","v":0},{"$f":"Assumptions!H31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"             Permanent Staff Positions",null,null,null,{"$f":"Assumptions!F32","v":0},{"$f":"Assumptions!G32","v":0},{"$f":"Assumptions!H32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"          Programs",null,null,null,{"$f":"Assumptions!F33","v":0},{"$f":"Assumptions!G33","v":0},{"$f":"Assumptions!H33","v":0},null,{"$f":"SUM(T34:T40)","v":529699},{"$f":"SUM(U34:U40)","v":545589.97},548238.46499999997,542941.47499999998,578816.39917300013,587286.74966962484,570427.8871718751]
[null,null,null,null,null,null,null,null,null,null,null,"             Weather Services",null,null,null,{"$f":"Assumptions!F34","v":0.03},{"$f":"Assumptions!G34","v":3.5000000000000003E-2},{"$f":"Assumptions!H34","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E34","v":60883},{"$f":"(1+P34)*$T34","v":62709.490000000005},{"$f":"(1+Q34)*$T34","v":63013.904999999992},{"$f":"(1+R34)*$T34","v":62405.074999999997},{"$f":"POWER(1+P34,3)*$T34","v":66528.497940999994},{"$f":"POWER(1+Q34,3)*$T34","v":67502.070383624989},{"$f":"POWER(1+R34,3)*$T34","v":65564.331921874997}]
[null,null,null,null,null,null,null,null,null,null,null,"             School (contract/non-contract)",null,null,null,{"$f":"Assumptions!F35","v":0.03},{"$f":"Assumptions!G35","v":3.5000000000000003E-2},{"$f":"Assumptions!H35","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E35","v":79200},81576,81972,81180,86543.978400000007,87810.455699999977,85289.737499999988]
[null,null,null,null,null,null,null,null,null,null,null,"             Museum Shop Costs",null,null,null,{"$f":"Assumptions!F36","v":0.03},{"$f":"Assumptions!G36","v":3.5000000000000003E-2},{"$f":"Assumptions!H36","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E36","v":47716},49147.48,49386.06,48908.899999999994,52140.561532,52903.582123499989,51384.913062499996]
[null,null,null,null,null,null,null,null,null,null,null,"             Collections, Kitchel",null,null,null,{"$f":"Assumptions!F37","v":0.03},{"$f":"Assumptions!G37","v":3.5000000000000003E-2},{"$f":"Assumptions!H37","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E37","v":91090},93822.7,94278.15,93367.249999999985,99536.502429999993,100993.11123374998,98093.967031249995]
[null,null,null,null,null,null,null,null,null,null,null,"             Planetarium and Oth. Programs",null,null,null,{"$f":"Assumptions!F38","v":0.03},{"$f":"Assumptions!G38","v":3.5000000000000003E-2},{"$f":"Assumptions!H38","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E38","v":151266},155803.98000000001,156560.31,155047.65,165292.44238200001,167711.31807974997,162896.93728124999]
[null,null,null,null,null,null,null,null,null,null,null,"             Exhibits and Planning",null,null,null,{"$f":"Assumptions!F39","v":0.03},{"$f":"Assumptions!G39","v":3.5000000000000003E-2},{"$f":"Assumptions!H39","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E39","v":75778},78051.34,78430.23,77672.45,82804.666605999999,84016.42313174998,81604.617781249995]
[null,null,null,null,null,null,null,null,null,null,null,"             Festival, Auction, Visitor, etc.",null,null,null,{"$f":"Assumptions!F40","v":0.03},{"$f":"Assumptions!G40","v":3.5000000000000003E-2},{"$f":"Assumptions!H40","v":2.5000000000000001E-2},null,{"$f":"Assumptions!E40","v":23766},24478.98,24597.809999999998,24360.149999999998,25969.749882,26349.789017249994,25593.382593749997]
[null,null,null,null,null,null,null,null,null,null,null,"          Facilities and Equipment",null,null,null,{"$f":"Assumptions!F41","v":0.02},{"$f":"Assumptions!G41","v":2.5000000000000001E-2},{"$f":"Assumptions!H41","v":1.7500000000000002E-2},null,{"$f":"Assumptions!E41","v":116074},118395.48,118975.84999999999,118105.29500000001,123178.65739199999,124999.00240624999,122275.15007159376]
[null,null,null,null,null,null,null,null,null,null,null,"          Administration",null,null,null,{"$f":"Assumptions!F42","v":0.02},{"$f":"Assumptions!G42","v":2.5000000000000001E-2},{"$f":"Assumptions!H42","v":1.7500000000000002E-2},null,{"$f":"Assumptions!E42","v":91592},93423.84,93881.799999999988,93194.86,97198.163135999988,98634.566124999983,96485.221025875013]
[null,null,null,null,null,null,null,null,null,null,null,"          Development and Marketing",null,null,null,{"$f":"Assumptions!F43","v":0.08},{"$f":"Assumptions!G43","v":0.1},{"$f":"Assumptions!H43","v":0.06},null,{"$f":"Assumptions!E43","v":113741},122840.28000000001,125115.1,120565.46,143280.90259200003,151389.27100000004,135467.35085600003]
[null,null,null,null,null,null,null,null,null,null,null,"     Total costs",null,null,null,{"$f":"Assumptions!F44","v":0},{"$f":"Assumptions!G44","v":0},{"$f":"Assumptions!H44","v":0},null,{"$f":"SUM(T34:T43)","v":851106},{"$f":"SUM(U34:U43)","v":880249.57},886211.21499999997,874807.09,942474.12229300011,962309.58920087491,924655.60912534408]
[null,null,null,null,null,null,null,null,null,null,null,"     Capital Expense",null,null,null,{"$f":"Assumptions!F45","v":0},{"$f":"Assumptions!G45","v":0},{"$f":"Assumptions!H45","v":0},null,{"$f":"Assumptions!E45","v":72100}]
[null,null,null,null,null,null,null,null,null,null,null,"     Expansion Planning",null,null,null,{"$f":"Assumptions!F46","v":0},{"$f":"Assumptions!G46","v":0},{"$f":"Assumptions!H46","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Operating surplus/deficit",null,null,null,null,null,null,null,{"$f":"T26-T44","v":0},{"$f":"U26-U44","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Check [(non-personnel+personnel)-total costs?]",null,null,null,null,null,null,null,{"$f":"SUM(T29:T30)-T44","v":-2},1341.1025000001537,-10997.089999999967,13160.130000000005,3496.9782780781388,-36792.285081499955,42133.75297265593]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Endowment"]
[null,null,null,null,null,null,null,null,null,null,null,"       Beginning of year",null,null,null,null,null,null,null,{"$f":"Assumptions!E53","v":1823127.6900000002},{"$f":"T58","v":1959640.6283000002},{"$f":"$T58","v":1959640.6283000002},{"$f":"$T58","v":1959640.6283000002},{"$f":"'5.8 Long-term Model'!$H$58","v":2708535.6575406701},{"$f":"'5.8 Long-term Model'!$H$58","v":2708535.6575406701},{"$f":"'5.8 Long-term Model'!$H$58","v":2708535.6575406701}]
[null,null,null,null,null,null,null,null,null,null,null,"          Contributions from Capital Campaign",null,null,null,{"$f":"Assumptions!F54","v":253600},{"$f":"Assumptions!G54","v":356160},{"$f":"Assumptions!H54","v":263696},null,{"$f":"Assumptions!E54","v":80000},{"$f":"Assumptions!$F$54","v":253600},{"$f":"Assumptions!$F$54","v":253600},{"$f":"Assumptions!$F$54","v":253600},{"$f":"Assumptions!$H$54","v":263696},{"$f":"Assumptions!$H$54","v":263696},{"$f":"Assumptions!$H$54","v":263696}]
[null,null,null,null,null,null,null,null,null,null,null,"          Interest to Investment Income",null,null,null,{"$f":"Assumptions!F62","v":0.08},{"$f":"Assumptions!G62","v":0.05},{"$f":"Assumptions!H62","v":0.1},null,{"$f":"T53*(P55)","v":145850.21520000001},{"$f":"($P$55)*U$53","v":156771.25026400003},{"$f":"($Q$55)*V$53","v":97982.031415000019},{"$f":"($R$55)*W$53","v":195964.06283000004},{"$f":"($P$55)*X$53","v":216682.85260325362},{"$f":"($Q$55)*Y$53","v":135426.78287703352},{"$f":"($R$55)*Z$53","v":270853.56575406704}]
[null,null,null,null,null,null,null,null,null,null,null,"          Withdrawal for operations",null,null,null,null,null,null,null,{"$f":"T44-(SUM(T14:T24)-T19)","v":71106},76023.569999999949,92070.214999999967,62892.089999999967,86730.616893000086,138647.41650087491,44061.81312534411]
[null,null,null,null,null,null,null,null,null,null,null,"          Investment Management Fee",null,null,null,null,null,null,null,{"$f":"T53*Assumptions!E63","v":18231.276900000001},{"$f":"Assumptions!$E$63*U53","v":19596.406283000004},{"$f":"Assumptions!$E$63*V53","v":19596.406283000004},{"$f":"Assumptions!$E$63*W53","v":19596.406283000004},{"$f":"Assumptions!$E$63*X53","v":27085.356575406702},{"$f":"Assumptions!$E$63*Y53","v":27085.356575406702},{"$f":"Assumptions!$E$63*Z53","v":27085.356575406702}]
[null,null,null,null,null,null,null,null,null,null,null,"       End of year",null,null,null,null,null,null,null,{"$f":"SUM(T53:T55)-SUM(T56:T57)","v":1959640.6283000002},2274391.9022810003,2199556.0384320002,2326716.1948470003,3075098.536675517,2941925.6673414223,3171938.0535939867]

{"sheet":"Historical data","index":8,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]
["SGP"]
[]
["Historical Data",null,null,null,null,null,"Growth Rates","est",null,null,"Two-Year","Three-Year"]
[null,null,null,"Est",null,null,"actual","projected","actual",null,"Average","Average"]
["CURRENT MUSEUM OPERATIONS",2003,2004,2005,2006,null,"2004 as %","2005 as %","2005 as %","2006 as %","Ann. Rate","Ann. Rate"]
[null,"Actual","Actual","Actual","Projected",null,"of 2003","of 2004","of 2004","of 2005","2005/2003","2006/2003"]
["Revenues"]
["          Grants"]
["               Municipal",55000,60000,{"$f":"Assumptions!D11","v":65000},null,null,{"$f":"(C11/B11)-1","v":9.0909090909090828E-2},{"$f":"(D11/C11)-1","v":8.3333333333333259E-2}]
["               Federal",75000,112500,{"$f":"Assumptions!D12","v":131500},null,null,{"$f":"(C12/B12)-1","v":0.5},{"$f":"(D12/C12)-1","v":0.16888888888888887}]
["               Foundations",70000,60000,{"$f":"Assumptions!D13","v":62500},null,null,-0.1428571428571429,4.1666666666666741E-2]
["               Total grants",{"$f":"SUM(B11:B13)","v":200000},{"$f":"SUM(C11:C13)","v":232500},{"$f":"Assumptions!D14","v":259000},null,null,0.16250000000000009,0.11397849462365595]
["         Sponsorships",15000,12000,{"$f":"Assumptions!D15","v":15500},null,null,-0.19999999999999996,0.29166666666666674]
["         Admissions",66000,68000,{"$f":"Assumptions!D16","v":60000},null,null,3.0303030303030276E-2,-0.11764705882352944]
["         Gross Retail Sales",56000,58050,{"$f":"Assumptions!D17","v":59500},null,null,3.6607142857142838E-2,2.4978466838931901E-2]
["         Public programs & events",64406,44400,{"$f":"Assumptions!D18","v":46126},null,null,-0.31062323386019941,3.8873873873873865E-2]
["         Fees for Services",107625,123100,{"$f":"Assumptions!D19","v":118194},null,null,0.14378629500580731,-3.9853777416734348E-2]
["            Weather Services",null,null,{"$f":"Assumptions!D20","v":36000},null,null,null,{"$error":"#DIV/0!"}]
["            School (contract/non-contract)",null,null,{"$f":"Assumptions!D21","v":82194},null,null,null,{"$error":"#DIV/0!"}]
["         Annual Fund",65000,90000,{"$f":"Assumptions!D22","v":80000},null,null,{"$f":"(C22/B22)-1","v":0.38461538461538458},-0.11111111111111116]
["         Contributions and membership",49000,53000,{"$f":"Assumptions!D23","v":34000},null,null,{"$f":"(C23/B23)-1","v":8.163265306122458E-2},-0.35849056603773588]
["         Other Gifts",null,null,{"$f":"Assumptions!D24","v":55500},null,null,null,{"$error":"#DIV/0!"}]
["         Endowment withdrawal",146000,{"$f":"C54","v":137156},{"$f":"Assumptions!D25","v":75000},null,null,{"$f":"(C25/B25)-1","v":-6.0575342465753468E-2},-0.45317740383213279]
["     Total revenues",{"$f":"SUM(B14:B25)","v":769031},{"$f":"SUM(C14:C25)","v":818206},{"$f":"Assumptions!D26","v":802820},null,null,{"$f":"(C26/B26)-1","v":6.3944106284402169E-2},-1.8804555332031292E-2]
[]
["Costs"]
["          Non-Personnel",300127,256568,{"$f":"Assumptions!D29","v":267299},null,null,{"$f":"(C29/B29)-1","v":-0.14513522608762286},4.182516915593526E-2]
["          Personnel",489722,473853,{"$f":"Assumptions!D30","v":525042},null,null,{"$f":"(C30/B30)-1","v":-3.2404098651888202E-2},0.10802717298402675]
["             Temporary Staff Positions",null,null,{"$f":"Assumptions!E31","v":0}]
["             Permanent Staff Positions",null,null,{"$f":"Assumptions!E32","v":0}]
["          Programs",140160,{"$f":"Assumptions!C33","v":444084},{"$f":"Assumptions!D33","v":445659},null,null,{"$f":"(C33/B33)-1","v":2.1684075342465752},3.5466263139405374E-3]
["             Weather Services",null,49412,{"$f":"Assumptions!D34","v":60323},null,null,{"$error":"#DIV/0!"},0.22081680563425898]
["             School (contract/non-contract)",null,70848,{"$f":"Assumptions!D35","v":67709},null,null,{"$error":"#DIV/0!"},-4.4306120144534833E-2]
["             Museum Shop Costs",null,40424,{"$f":"Assumptions!D36","v":45619},null,null,{"$error":"#DIV/0!"},0.128512764694241]
["             Collections, Kitchel",null,51693,{"$f":"Assumptions!D37","v":81789},null,null,{"$error":"#DIV/0!"},0.58220648830596011]
["             Planetarium and Oth. Programs",null,69365,{"$f":"Assumptions!D38","v":49700},null,null,{"$error":"#DIV/0!"},-0.28350032437108053]
["             Exhibits and Planning",null,117316,{"$f":"Assumptions!D39","v":93859},null,null,{"$error":"#DIV/0!"},-0.19994715128371232]
["             Festival, Auction, Visitor, etc.",null,45026,{"$f":"Assumptions!D40","v":46660},null,null,{"$error":"#DIV/0!"},3.629014347266013E-2]
["          Facilities and Equipment",68700,88687,{"$f":"Assumptions!D41","v":103087},null,null,0.29093158660844254,0.16236878009178346]
["          Administration",56967,131739,{"$f":"Assumptions!D42","v":118631},null,null,null,-9.9499768481619011E-2]
["          Development and Marketing",34300,78142,{"$f":"Assumptions!D43","v":91909},null,null,{"$f":"(C42/B42)-1","v":1.3125493706882931},0.17617926339228585]
["     Total costs",{"$f":"SUM(B30:B43)","v":789849},{"$f":"SUM(C34:C43)","v":742652},{"$f":"SUM(D34:D43)","v":759286},null,null,null,2.2398108400704553E-2]
["          Capital Expense",null,11194,{"$f":"Assumptions!D45","v":0},null,null,{"$f":"(C43/B43)-1","v":1.2781924198250727},-1]
["          Expansion Planning",null,46581,{"$f":"Assumptions!D46","v":0},null,null,-5.9754459396669457E-2,-1]
[]
["Operating surplus/deficit",{"$f":"B26-B44","v":-20818},{"$f":"C26-C44","v":75554},0,null,null,{"$error":"#DIV/0!"},-1]
[]
["Endowment",null,null,null,null,null,-4.6292631376693247,{"$f":"(D48/C48)-1","v":-1}]
["       Beginning of year",null,1654000,1596892,null,null,{"$error":"#DIV/0!"},{"$f":"(D51/C51)-1","v":-3.4527206771463148E-2}]
["          Add. Endowment Contrib.",null,52043,52000,null,null,{"$error":"#DIV/0!"},-8.2623984013219243E-4]
["          Interest to Investment Income",null,132320,127751.36,null,null,{"$error":"#DIV/0!"},-3.4527206771463148E-2]
["          Withdrawal for operations",null,137156,127041,null,null,null,-7.3748140803173046E-2]
["          Withdrawal for Capital Expense/Planning",null,57775,0,null,null,null,-1]
["          Special withdrawal",null,30000,0,null,null,{"$f":"(C54/B54)-1","v":{"$error":"#DIV/0!"}},-1]
["          Investment Management Fee",null,16540,15968.92,null,null,{"$f":"(C55/B55)-1","v":{"$error":"#DIV/0!"}},-3.4527206771463148E-2]
["       End of year",1654000,1596892,1633633.44,null,null,{"$f":"(C56/B56)-1","v":{"$error":"#DIV/0!"}},2.3008093221081882E-2]

{"sheet":"Ratio charts","index":9,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Northern Museum"]
["Prototype Planning Model"]